Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	1134
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	133.0 KiB
Average record size in memory	120.1 B

Variable types

Categorical	4
Numeric	11

Alerts

`2010` is highly overall correlated with `2011` and 9 other fields	High correlation
`2011` is highly overall correlated with `2010` and 9 other fields	High correlation
`2012` is highly overall correlated with `2010` and 9 other fields	High correlation
`2013` is highly overall correlated with `2010` and 9 other fields	High correlation
`2014` is highly overall correlated with `2010` and 9 other fields	High correlation
`2015` is highly overall correlated with `2010` and 9 other fields	High correlation
`2016` is highly overall correlated with `2010` and 9 other fields	High correlation
`2017` is highly overall correlated with `2010` and 9 other fields	High correlation
`2018` is highly overall correlated with `2010` and 9 other fields	High correlation
`2019` is highly overall correlated with `2010` and 9 other fields	High correlation
`2020` is highly overall correlated with `2010` and 9 other fields	High correlation
`Masseinheit` is uniformly distributed	Uniform
`Leistung` is uniformly distributed	Uniform
`Geschlecht` is uniformly distributed	Uniform
`Altersklasse` is uniformly distributed	Uniform

Reproduction

Analysis started	2022-12-28 08:18:36.339637
Analysis finished	2022-12-28 08:18:43.241202
Duration	6.9 seconds
Software version	pandas-profiling vv3.5.0
Download configuration	config.json

Masseinheit
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	9.0 KiB

Absolutwert	567
Wert pro Kopf und Monat	567

Length

Max length	23
Median length	17
Mean length	17
Min length	11

Characters and Unicode

Total characters	19278
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Absolutwert
2nd row	Absolutwert
3rd row	Absolutwert
4th row	Absolutwert
5th row	Absolutwert

Common Values

Value	Count	Frequency (%)
Absolutwert	567	50.0%
Wert pro Kopf und Monat	567	50.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
absolutwert	567	16.7%
wert	567	16.7%
pro	567	16.7%
kopf	567	16.7%
und	567	16.7%
monat	567	16.7%

Most occurring characters

Value	Count	Frequency (%)
o	2268	11.8%
t	2268	11.8%
	2268	11.8%
r	1701	8.8%
p	1134	5.9%
u	1134	5.9%
n	1134	5.9%
e	1134	5.9%
M	567	2.9%
d	567	2.9%
Other values (9)	5103	26.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14742	76.5%
Space Separator	2268	11.8%
Uppercase Letter	2268	11.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	2268	15.4%
t	2268	15.4%
r	1701	11.5%
p	1134	7.7%
u	1134	7.7%
n	1134	7.7%
e	1134	7.7%
d	567	3.8%
f	567	3.8%
b	567	3.8%
Other values (4)	2268	15.4%

Uppercase Letter

Value	Count	Frequency (%)
M	567	25.0%
K	567	25.0%
A	567	25.0%
W	567	25.0%

Space Separator

Value	Count	Frequency (%)
	2268	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17010	88.2%
Common	2268	11.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	2268	13.3%
t	2268	13.3%
r	1701	10.0%
p	1134	6.7%
u	1134	6.7%
n	1134	6.7%
e	1134	6.7%
M	567	3.3%
d	567	3.3%
f	567	3.3%
Other values (8)	4536	26.7%

Common

Value	Count	Frequency (%)
	2268	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19278	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	2268	11.8%
t	2268	11.8%
	2268	11.8%
r	1701	8.8%
p	1134	5.9%
u	1134	5.9%
n	1134	5.9%
e	1134	5.9%
M	567	2.9%
d	567	2.9%
Other values (9)	5103	26.5%

Leistung
Categorical

Distinct	9
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	9.0 KiB

Leistung - Total	126
Stationäre Kurativbehandlung	126
Ambulante Kurativbehandlung	126
Rehabilitation	126
Langzeitpflege	126
Other values (4)	504

Length

Max length	31
Median length	27
Mean length	18.444444
Min length	10

Characters and Unicode

Total characters	20916
Distinct characters	35
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Leistung - Total
2nd row	Leistung - Total
3rd row	Leistung - Total
4th row	Leistung - Total
5th row	Leistung - Total

Common Values

Value	Count	Frequency (%)
Leistung - Total	126	11.1%
Stationäre Kurativbehandlung	126	11.1%
Ambulante Kurativbehandlung	126	11.1%
Rehabilitation	126	11.1%
Langzeitpflege	126	11.1%
Unterstützende Dienstleistungen	126	11.1%
Gesundheitsgüter	126	11.1%
Prävention	126	11.1%
Verwaltung	126	11.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
kurativbehandlung	252	14.3%
leistung	126	7.1%
	126	7.1%
total	126	7.1%
stationäre	126	7.1%
ambulante	126	7.1%
rehabilitation	126	7.1%
langzeitpflege	126	7.1%
unterstützende	126	7.1%
dienstleistungen	126	7.1%
Other values (3)	378	21.4%

Most occurring characters

Value	Count	Frequency (%)
e	2520	12.0%
t	2394	11.4%
n	2268	10.8%
i	1512	7.2%
a	1386	6.6%
u	1134	5.4%
g	1008	4.8%
l	1008	4.8%
r	882	4.2%
s	756	3.6%
Other values (25)	6048	28.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	18522	88.6%
Uppercase Letter	1638	7.8%
Space Separator	630	3.0%
Dash Punctuation	126	0.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2520	13.6%
t	2394	12.9%
n	2268	12.2%
i	1512	8.2%
a	1386	7.5%
u	1134	6.1%
g	1008	5.4%
l	1008	5.4%
r	882	4.8%
s	756	4.1%
Other values (12)	3654	19.7%

Uppercase Letter

Value	Count	Frequency (%)
L	252	15.4%
K	252	15.4%
S	126	7.7%
A	126	7.7%
R	126	7.7%
T	126	7.7%
U	126	7.7%
D	126	7.7%
G	126	7.7%
P	126	7.7%

Space Separator

Value	Count	Frequency (%)
	630	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	126	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	20160	96.4%
Common	756	3.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2520	12.5%
t	2394	11.9%
n	2268	11.2%
i	1512	7.5%
a	1386	6.9%
u	1134	5.6%
g	1008	5.0%
l	1008	5.0%
r	882	4.4%
s	756	3.8%
Other values (23)	5292	26.2%

Common

Value	Count	Frequency (%)
	630	83.3%
-	126	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20412	97.6%
None	504	2.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2520	12.3%
t	2394	11.7%
n	2268	11.1%
i	1512	7.4%
a	1386	6.8%
u	1134	5.6%
g	1008	4.9%
l	1008	4.9%
r	882	4.3%
s	756	3.7%
Other values (23)	5544	27.2%

None

Value	Count	Frequency (%)
ü	252	50.0%
ä	252	50.0%

Geschlecht
Categorical

Distinct	3
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	9.0 KiB

Geschlecht - Total	378
Mann	378
Frau	378

Length

Max length	18
Median length	4
Mean length	8.6666667
Min length	4

Characters and Unicode

Total characters	9828
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Geschlecht - Total
2nd row	Geschlecht - Total
3rd row	Geschlecht - Total
4th row	Geschlecht - Total
5th row	Geschlecht - Total

Common Values

Value	Count	Frequency (%)
Geschlecht - Total	378	33.3%
Mann	378	33.3%
Frau	378	33.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
geschlecht	378	20.0%
	378	20.0%
total	378	20.0%
mann	378	20.0%
frau	378	20.0%

Most occurring characters

Value	Count	Frequency (%)
a	1134	11.5%
c	756	7.7%
h	756	7.7%
l	756	7.7%
t	756	7.7%
	756	7.7%
e	756	7.7%
n	756	7.7%
G	378	3.8%
M	378	3.8%
Other values (7)	2646	26.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7182	73.1%
Uppercase Letter	1512	15.4%
Space Separator	756	7.7%
Dash Punctuation	378	3.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1134	15.8%
c	756	10.5%
h	756	10.5%
l	756	10.5%
t	756	10.5%
e	756	10.5%
n	756	10.5%
r	378	5.3%
o	378	5.3%
s	378	5.3%

Uppercase Letter

Value	Count	Frequency (%)
G	378	25.0%
M	378	25.0%
F	378	25.0%
T	378	25.0%

Space Separator

Value	Count	Frequency (%)
	756	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	378	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8694	88.5%
Common	1134	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1134	13.0%
c	756	8.7%
h	756	8.7%
l	756	8.7%
t	756	8.7%
e	756	8.7%
n	756	8.7%
G	378	4.3%
M	378	4.3%
r	378	4.3%
Other values (5)	1890	21.7%

Common

Value	Count	Frequency (%)
	756	66.7%
-	378	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9828	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1134	11.5%
c	756	7.7%
h	756	7.7%
l	756	7.7%
t	756	7.7%
	756	7.7%
e	756	7.7%
n	756	7.7%
G	378	3.8%
M	378	3.8%
Other values (7)	2646	26.9%

Altersklasse
Categorical

Distinct	21
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	9.0 KiB

Altersklasse - Total	54
51-55 Jahre	54
91-95 Jahre	54
86-90 Jahre	54
81-85 Jahre	54
Other values (16)	864

Length

Max length	20
Median length	11
Mean length	11.571429
Min length	9

Characters and Unicode

Total characters	13122
Distinct characters	28
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Altersklasse - Total
2nd row	0-5 Jahre
3rd row	6-10 Jahre
4th row	11-15 Jahre
5th row	16-20 Jahre

Common Values

Value	Count	Frequency (%)
Altersklasse - Total	54	4.8%
51-55 Jahre	54	4.8%
91-95 Jahre	54	4.8%
86-90 Jahre	54	4.8%
81-85 Jahre	54	4.8%
76-80 Jahre	54	4.8%
71-75 Jahre	54	4.8%
66-70 Jahre	54	4.8%
61-65 Jahre	54	4.8%
56-60 Jahre	54	4.8%
Other values (11)	594	52.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
jahre	1080	44.4%
altersklasse	54	2.2%
0-5	54	2.2%
und	54	2.2%
96	54	2.2%
6-10	54	2.2%
11-15	54	2.2%
16-20	54	2.2%
21-25	54	2.2%
26-30	54	2.2%
Other values (16)	864	35.6%

Most occurring characters

Value	Count	Frequency (%)
	1296	9.9%
e	1242	9.5%
r	1188	9.1%
a	1188	9.1%
h	1134	8.6%
J	1080	8.2%
-	1080	8.2%
6	756	5.8%
5	756	5.8%
1	702	5.3%
Other values (18)	2700	20.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5508	42.0%
Decimal Number	4050	30.9%
Space Separator	1296	9.9%
Uppercase Letter	1188	9.1%
Dash Punctuation	1080	8.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1242	22.5%
r	1188	21.6%
a	1188	21.6%
h	1134	20.6%
l	162	2.9%
s	162	2.9%
t	108	2.0%
n	54	1.0%
d	54	1.0%
u	54	1.0%
Other values (3)	162	2.9%

Decimal Number

Value	Count	Frequency (%)
6	756	18.7%
5	756	18.7%
1	702	17.3%
0	540	13.3%
4	216	5.3%
7	216	5.3%
8	216	5.3%
9	216	5.3%
3	216	5.3%
2	216	5.3%

Uppercase Letter

Value	Count	Frequency (%)
J	1080	90.9%
A	54	4.5%
T	54	4.5%

Space Separator

Value	Count	Frequency (%)
	1296	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1080	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6696	51.0%
Common	6426	49.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1242	18.5%
r	1188	17.7%
a	1188	17.7%
h	1134	16.9%
J	1080	16.1%
l	162	2.4%
s	162	2.4%
t	108	1.6%
n	54	0.8%
d	54	0.8%
Other values (6)	324	4.8%

Common

Value	Count	Frequency (%)
	1296	20.2%
-	1080	16.8%
6	756	11.8%
5	756	11.8%
1	702	10.9%
0	540	8.4%
4	216	3.4%
7	216	3.4%
8	216	3.4%
9	216	3.4%
Other values (2)	432	6.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13122	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1296	9.9%
e	1242	9.5%
r	1188	9.1%
a	1188	9.1%
h	1134	8.6%
J	1080	8.2%
-	1080	8.2%
6	756	5.8%
5	756	5.8%
1	702	5.3%
Other values (18)	2700	20.6%

2010
Real number (ℝ)

Distinct	1099
Distinct (%)	96.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	590.92492

Minimum	0.4
Maximum	62564.98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.4
5-th percentile	13.999
Q1	39.85
median	109.045
Q3	352.195
95-th percentile	2317.954
Maximum	62564.98
Range	62564.58
Interquartile range (IQR)	312.345

Descriptive statistics

Standard deviation	2579.3335
Coefficient of variation (CV)	4.364909
Kurtosis	336.26978
Mean	590.92492
Median Absolute Deviation (MAD)	89.885
Skewness	16.116223
Sum	670108.86
Variance	6652961.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.8	4	0.4%
18.12	4	0.4%
17.98	3	0.3%
18.05	3	0.3%
17.92	3	0.3%
17.97	3	0.3%
52.92	2	0.2%
24.5	2	0.2%
78.04	2	0.2%
18.27	2	0.2%
Other values (1089)	1106	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.4	1	0.1%
0.79	1	0.1%
1.05	1	0.1%
1.49	1	0.1%
1.89	1	0.1%
1.95	1	0.1%
3.14	1	0.1%
3.15	1	0.1%
3.89	1	0.1%
3.93	1	0.1%

Value	Count	Frequency (%)
62564.98	1	0.1%
36086.94	1	0.1%
26478.04	1	0.1%
15808.31	1	0.1%
13373.44	1	0.1%
12589.32	1	0.1%
10083.01	1	0.1%
8955.02	1	0.1%
8250.52	1	0.1%
7912.46	1	0.1%

2011
Real number (ℝ)

Distinct	1090
Distinct (%)	96.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	609.47864

Minimum	0.4
Maximum	64242.69
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.4
5-th percentile	14.7855
Q1	41.62
median	113.21
Q3	358.645
95-th percentile	2394.112
Maximum	64242.69
Range	64242.29
Interquartile range (IQR)	317.025

Descriptive statistics

Standard deviation	2655.4806
Coefficient of variation (CV)	4.3569708
Kurtosis	332.6733
Mean	609.47864
Median Absolute Deviation (MAD)	92.605
Skewness	16.002823
Sum	691148.78
Variance	7051577.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.03	4	0.4%
17.62	3	0.3%
17.79	3	0.3%
17.93	3	0.3%
17.89	3	0.3%
18.06	3	0.3%
17.81	3	0.3%
43.93	2	0.2%
14.89	2	0.2%
57.83	2	0.2%
Other values (1080)	1106	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.4	1	0.1%
1.24	2	0.2%
1.46	1	0.1%
1.86	1	0.1%
2.12	1	0.1%
3.15	1	0.1%
3.28	1	0.1%
3.91	1	0.1%
3.92	1	0.1%
4.16	1	0.1%

Value	Count	Frequency (%)
64242.69	1	0.1%
37043.97	1	0.1%
27198.72	1	0.1%
16108.75	1	0.1%
13582.55	1	0.1%
13256.77	1	0.1%
10097.63	1	0.1%
9105.68	1	0.1%
8805.66	1	0.1%
8700.65	1	0.1%

2012
Real number (ℝ)

Distinct	1095
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	628.64144

Minimum	0.38
Maximum	66512.44
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.38
5-th percentile	14.3375
Q1	41.8125
median	114.375
Q3	374.815
95-th percentile	2483.827
Maximum	66512.44
Range	66512.06
Interquartile range (IQR)	333.0025

Descriptive statistics

Standard deviation	2748.7341
Coefficient of variation (CV)	4.3724991
Kurtosis	332.70933
Mean	628.64144
Median Absolute Deviation (MAD)	93.63
Skewness	16.007063
Sum	712879.39
Variance	7555539.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.56	4	0.4%
17.67	3	0.3%
17.52	3	0.3%
17.8	3	0.3%
17.71	3	0.3%
17.45	3	0.3%
17.65	3	0.3%
17.64	3	0.3%
34.6	2	0.2%
172.34	2	0.2%
Other values (1085)	1105	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.38	1	0.1%
0.87	1	0.1%
1.27	1	0.1%
1.42	1	0.1%
1.8	1	0.1%
2.28	1	0.1%
3.06	1	0.1%
3.32	1	0.1%
3.94	1	0.1%
3.98	1	0.1%

Value	Count	Frequency (%)
66512.44	1	0.1%
38167.59	1	0.1%
28344.85	1	0.1%
16924.49	1	0.1%
14176.31	1	0.1%
13831.65	1	0.1%
10181.46	1	0.1%
9503.46	1	0.1%
9054.41	1	0.1%
8963.82	1	0.1%

2013
Real number (ℝ)

Distinct	1094
Distinct (%)	96.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	651.40499

Minimum	0.39
Maximum	69118.03
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.39
5-th percentile	14.715
Q1	44.1
median	117.865
Q3	392.8075
95-th percentile	2532.4805
Maximum	69118.03
Range	69117.64
Interquartile range (IQR)	348.7075

Descriptive statistics

Standard deviation	2854.2571
Coefficient of variation (CV)	4.3816936
Kurtosis	333.42098
Mean	651.40499
Median Absolute Deviation (MAD)	96.845
Skewness	16.027871
Sum	738693.26
Variance	8146783.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.46	4	0.4%
18.5	4	0.4%
18.2	3	0.3%
18.31	3	0.3%
18.39	3	0.3%
18.44	3	0.3%
18.28	3	0.3%
18.29	3	0.3%
18.07	3	0.3%
18.18	3	0.3%
Other values (1084)	1102	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.39	1	0.1%
1.17	1	0.1%
1.49	1	0.1%
1.54	1	0.1%
1.88	1	0.1%
2.49	1	0.1%
3.18	1	0.1%
3.93	1	0.1%
3.99	1	0.1%
4.12	1	0.1%

Value	Count	Frequency (%)
69118.03	1	0.1%
39477.83	1	0.1%
29640.21	1	0.1%
17687.57	1	0.1%
14791.18	1	0.1%
14255.11	1	0.1%
10418.93	1	0.1%
9917.54	1	0.1%
9295.71	1	0.1%
9136.33	1	0.1%

2014
Real number (ℝ)

Distinct	1095
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	669.76481

Minimum	0.41
Maximum	71429.22
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.41
5-th percentile	14.7125
Q1	45.8875
median	120.58
Q3	405.0875
95-th percentile	2578.748
Maximum	71429.22
Range	71428.81
Interquartile range (IQR)	359.2

Descriptive statistics

Standard deviation	2946.2652
Coefficient of variation (CV)	4.3989549
Kurtosis	334.89803
Mean	669.76481
Median Absolute Deviation (MAD)	99.01
Skewness	16.076803
Sum	759513.29
Variance	8680478.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.79	4	0.4%
19.01	3	0.3%
19	3	0.3%
18.97	3	0.3%
19.04	3	0.3%
18.56	2	0.2%
308.98	2	0.2%
18.96	2	0.2%
120.58	2	0.2%
19.08	2	0.2%
Other values (1085)	1108	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.41	1	0.1%
1.24	1	0.1%
1.55	1	0.1%
1.72	1	0.1%
1.96	1	0.1%
2.72	1	0.1%
3.83	1	0.1%
3.93	1	0.1%
4.05	1	0.1%
4.17	1	0.1%

Value	Count	Frequency (%)
71429.22	1	0.1%
40685.88	1	0.1%
30743.35	1	0.1%
18680.79	1	0.1%
14947.37	1	0.1%
14627.86	1	0.1%
10604.07	1	0.1%
10447.26	1	0.1%
9502	1	0.1%
9378.68	1	0.1%

2015
Real number (ℝ)

Distinct	1097
Distinct (%)	96.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	693.87709

Minimum	0.42
Maximum	74384.64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.42
5-th percentile	15.145
Q1	47.215
median	124.73
Q3	416.315
95-th percentile	2684.3615
Maximum	74384.64
Range	74384.22
Interquartile range (IQR)	369.1

Descriptive statistics

Standard deviation	3061.8626
Coefficient of variation (CV)	4.4126872
Kurtosis	337.3768
Mean	693.87709
Median Absolute Deviation (MAD)	103.165
Skewness	16.151821
Sum	786856.62
Variance	9375002.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.87	4	0.4%
18.99	4	0.4%
19.07	4	0.4%
19.02	4	0.4%
18.85	3	0.3%
18.72	3	0.3%
228.7	2	0.2%
332.53	2	0.2%
18.58	2	0.2%
25.59	2	0.2%
Other values (1087)	1104	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.42	1	0.1%
1.57	1	0.1%
1.79	1	0.1%
1.87	1	0.1%
1.99	1	0.1%
2.86	1	0.1%
3.63	1	0.1%
4.01	1	0.1%
4.23	1	0.1%
4.49	1	0.1%

Value	Count	Frequency (%)
74384.64	1	0.1%
42162.1	1	0.1%
32222.54	1	0.1%
19541.36	1	0.1%
15385.88	1	0.1%
15129.31	1	0.1%
11100.11	1	0.1%
10924.17	1	0.1%
9795.49	1	0.1%
9376.99	1	0.1%

2016
Real number (ℝ)

Distinct	1098
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	715.14457

Minimum	0.48
Maximum	77455.23
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.48
5-th percentile	16.1
Q1	49.03
median	131.425
Q3	428.025
95-th percentile	2795.9655
Maximum	77455.23
Range	77454.75
Interquartile range (IQR)	378.995

Descriptive statistics

Standard deviation	3175.7719
Coefficient of variation (CV)	4.4407412
Kurtosis	342.67585
Mean	715.14457
Median Absolute Deviation (MAD)	107.845
Skewness	16.316584
Sum	810973.94
Variance	10085527
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.94	4	0.4%
18.99	3	0.3%
18.98	3	0.3%
18.8	3	0.3%
18.66	2	0.2%
18.79	2	0.2%
45.26	2	0.2%
17.61	2	0.2%
18.96	2	0.2%
18.53	2	0.2%
Other values (1088)	1109	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.48	1	0.1%
1.71	1	0.1%
1.85	1	0.1%
2.19	1	0.1%
2.21	1	0.1%
2.99	1	0.1%
3.22	1	0.1%
3.67	1	0.1%
4.13	1	0.1%
4.21	1	0.1%

Value	Count	Frequency (%)
77455.23	1	0.1%
43816.58	1	0.1%
33638.65	1	0.1%
20436.38	1	0.1%
15758	1	0.1%
15448.68	1	0.1%
11702.09	1	0.1%
11386.25	1	0.1%
9990.27	1	0.1%
9078.64	1	0.1%

2017
Real number (ℝ)

Distinct	1099
Distinct (%)	96.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	732.2367

Minimum	0.53
Maximum	79643.01
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.53
5-th percentile	16.2315
Q1	50.905
median	133.835
Q3	430.6975
95-th percentile	2918.407
Maximum	79643.01
Range	79642.48
Interquartile range (IQR)	379.7925

Descriptive statistics

Standard deviation	3261.2407
Coefficient of variation (CV)	4.4538066
Kurtosis	344.54492
Mean	732.2367
Median Absolute Deviation (MAD)	109.785
Skewness	16.375394
Sum	830356.42
Variance	10635691
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.89	4	0.4%
19.17	3	0.3%
19.28	3	0.3%
19.23	3	0.3%
19.33	3	0.3%
18.9	3	0.3%
97.7	2	0.2%
32.66	2	0.2%
32.46	2	0.2%
15.66	2	0.2%
Other values (1089)	1107	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.53	1	0.1%
1.87	1	0.1%
2.34	1	0.1%
2.4	1	0.1%
2.66	1	0.1%
2.74	1	0.1%
3.13	1	0.1%
3.39	1	0.1%
3.97	1	0.1%
4	1	0.1%

Value	Count	Frequency (%)
79643.01	1	0.1%
45081.09	1	0.1%
34561.92	1	0.1%
21108.17	1	0.1%
15942.85	1	0.1%
15718.28	1	0.1%
12088.35	1	0.1%
11891.76	1	0.1%
10247	1	0.1%
9216.41	1	0.1%

2018
Real number (ℝ)

Distinct	1101
Distinct (%)	97.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	735.35849

Minimum	0.62
Maximum	80241.83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.62
5-th percentile	15.7515
Q1	51.3425
median	136.205
Q3	434.2075
95-th percentile	2952.0795
Maximum	80241.83
Range	80241.21
Interquartile range (IQR)	382.865

Descriptive statistics

Standard deviation	3280.3179
Coefficient of variation (CV)	4.4608418
Kurtosis	346.61113
Mean	735.35849
Median Absolute Deviation (MAD)	112.505
Skewness	16.432022
Sum	833896.53
Variance	10760485
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.61	3	0.3%
20.87	3	0.3%
20.45	3	0.3%
20.71	3	0.3%
20.76	3	0.3%
59.18	2	0.2%
577.63	2	0.2%
20.98	2	0.2%
20.83	2	0.2%
21.06	2	0.2%
Other values (1091)	1109	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.62	1	0.1%
2.19	1	0.1%
2.44	1	0.1%
2.81	1	0.1%
2.88	1	0.1%
3.09	1	0.1%
3.58	1	0.1%
3.83	1	0.1%
4.53	1	0.1%
4.61	1	0.1%

Value	Count	Frequency (%)
80241.83	1	0.1%
45322.42	1	0.1%
34919.41	1	0.1%
20753.48	1	0.1%
16374.32	1	0.1%
15547.74	1	0.1%
12213.71	1	0.1%
11657.61	1	0.1%
10501.1	1	0.1%
9095.87	1	0.1%

2019
Real number (ℝ)

Distinct	1097
Distinct (%)	96.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	753.51953

Minimum	0.57
Maximum	82471.86
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.57
5-th percentile	16.683
Q1	52.4925
median	137.405
Q3	446.715
95-th percentile	3010.527
Maximum	82471.86
Range	82471.29
Interquartile range (IQR)	394.2225

Descriptive statistics

Standard deviation	3370.6081
Coefficient of variation (CV)	4.4731529
Kurtosis	346.85058
Mean	753.51953
Median Absolute Deviation (MAD)	113.48
Skewness	16.441986
Sum	854491.15
Variance	11360999
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.37	4	0.4%
17.51	4	0.4%
17.5	3	0.3%
17.84	3	0.3%
17.67	3	0.3%
17.95	3	0.3%
17.88	2	0.2%
313.81	2	0.2%
14.41	2	0.2%
35.5	2	0.2%
Other values (1087)	1106	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.57	1	0.1%
1.96	1	0.1%
2.53	1	0.1%
2.82	1	0.1%
3.19	1	0.1%
3.28	1	0.1%
3.33	1	0.1%
3.67	1	0.1%
4.15	1	0.1%
4.47	1	0.1%

Value	Count	Frequency (%)
82471.86	1	0.1%
46429.24	1	0.1%
36042.62	1	0.1%
21652.46	1	0.1%
16769.36	1	0.1%
15730.23	1	0.1%
12602.42	1	0.1%
12155.76	1	0.1%
10679.05	1	0.1%
9496.69	1	0.1%

2020
Real number (ℝ)

Distinct	1099
Distinct (%)	96.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	761.9802

Minimum	0.92
Maximum	83310.76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 KiB

Quantile statistics

Minimum	0.92
5-th percentile	16.6675
Q1	55.1475
median	148.415
Q3	450.125
95-th percentile	3055.541
Maximum	83310.76
Range	83309.84
Interquartile range (IQR)	394.9775

Descriptive statistics

Standard deviation	3396.5658
Coefficient of variation (CV)	4.4575512
Kurtosis	349.33392
Mean	761.9802
Median Absolute Deviation (MAD)	118.355
Skewness	16.495483
Sum	864085.55
Variance	11536659
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28.83	4	0.4%
12.19	3	0.3%
29.35	3	0.3%
29.37	3	0.3%
35.67	3	0.3%
29.33	3	0.3%
43.36	2	0.2%
42.23	2	0.2%
28.69	2	0.2%
29.11	2	0.2%
Other values (1089)	1107	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.92	1	0.1%
2.97	1	0.1%
2.98	1	0.1%
3.34	1	0.1%
3.35	1	0.1%
3.62	1	0.1%
4.22	1	0.1%
4.27	1	0.1%
4.45	1	0.1%
5.12	1	0.1%

Value	Count	Frequency (%)
83310.76	1	0.1%
46457.17	1	0.1%
36853.59	1	0.1%
20177.76	1	0.1%
17209.26	1	0.1%
16223.16	1	0.1%
12693.54	1	0.1%
11261.43	1	0.1%
10897.25	1	0.1%
9340.41	1	0.1%

Auto

The auto setting is an interpretable pairwise column metric of the following mapping:

Variable_type-Variable_type : Method, Range
Categorical-Categorical : Cramer's V, [0,1]
Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
Numerical-Numerical : Spearman's ρ, [-1,1]

The number of bins used in the discretization for the Numerical-Categorical column pair can be changed using config.correlations["auto"].n_bins. The number of bins affects the granularity of the association you wish to measure.

This configuration uses the recommended metric for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Masseinheit	Leistung	Geschlecht	Altersklasse	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020
0	Absolutwert	Leistung - Total	Geschlecht - Total	Altersklasse - Total	62564.98	64242.69	66512.44	69118.03	71429.22	74384.64	77455.23	79643.01	80241.83	82471.86	83310.76
1	Absolutwert	Leistung - Total	Geschlecht - Total	0-5 Jahre	1058.29	1081.82	1142.63	1201.47	1233.52	1286.22	1350.12	1397.85	1420.24	1446.21	1459.25
2	Absolutwert	Leistung - Total	Geschlecht - Total	6-10 Jahre	741.94	763.72	791.50	833.56	868.77	901.73	958.47	979.50	984.54	1030.28	1005.60
3	Absolutwert	Leistung - Total	Geschlecht - Total	11-15 Jahre	1167.69	1176.46	1187.57	1230.13	1274.32	1318.08	1367.32	1306.37	1257.24	1369.17	1574.17
4	Absolutwert	Leistung - Total	Geschlecht - Total	16-20 Jahre	1954.38	1966.64	2005.31	2032.15	2120.42	2215.10	2307.30	2400.91	2424.67	2481.64	2612.83
5	Absolutwert	Leistung - Total	Geschlecht - Total	21-25 Jahre	1965.46	2010.73	2119.64	2194.06	2259.24	2294.93	2376.53	2405.84	2391.39	2444.17	2404.88
6	Absolutwert	Leistung - Total	Geschlecht - Total	26-30 Jahre	2386.50	2439.34	2539.03	2621.64	2722.13	2830.68	2980.35	3097.86	3129.23	3192.41	3177.82
7	Absolutwert	Leistung - Total	Geschlecht - Total	31-35 Jahre	2762.71	2824.60	2966.20	3086.39	3215.50	3347.34	3500.12	3668.86	3698.74	3774.03	3849.67
8	Absolutwert	Leistung - Total	Geschlecht - Total	36-40 Jahre	3196.90	3164.66	2991.23	3066.49	3123.72	3215.41	3402.90	3637.26	3649.01	3780.84	3777.05
9	Absolutwert	Leistung - Total	Geschlecht - Total	41-45 Jahre	3632.71	3605.43	3437.49	3500.44	3522.34	3566.46	3645.10	3770.40	3706.78	3815.93	3794.40

	Masseinheit	Leistung	Geschlecht	Altersklasse	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020
1124	Wert pro Kopf und Monat	Verwaltung	Frau	51-55 Jahre	32.84	33.24	31.77	30.97	30.83	31.03	32.54	32.60	32.67	33.50	34.40
1125	Wert pro Kopf und Monat	Verwaltung	Frau	56-60 Jahre	37.25	37.55	35.81	34.36	33.93	34.18	35.75	35.80	35.94	36.61	37.43
1126	Wert pro Kopf und Monat	Verwaltung	Frau	61-65 Jahre	43.19	43.68	41.26	39.45	38.98	39.04	40.98	40.99	41.15	41.73	42.47
1127	Wert pro Kopf und Monat	Verwaltung	Frau	66-70 Jahre	51.15	52.41	49.66	47.50	46.90	47.12	48.72	48.56	48.77	49.72	50.46
1128	Wert pro Kopf und Monat	Verwaltung	Frau	71-75 Jahre	61.95	62.64	58.85	56.71	56.58	56.99	59.45	59.28	59.18	60.49	61.45
1129	Wert pro Kopf und Monat	Verwaltung	Frau	76-80 Jahre	75.69	76.76	72.29	69.66	69.47	69.23	72.09	71.80	71.95	72.92	74.65
1130	Wert pro Kopf und Monat	Verwaltung	Frau	81-85 Jahre	95.00	95.89	90.38	85.32	85.33	85.59	88.57	88.10	89.04	90.43	92.66
1131	Wert pro Kopf und Monat	Verwaltung	Frau	86-90 Jahre	123.04	125.73	117.60	110.56	109.59	108.81	111.12	111.39	112.46	114.52	119.10
1132	Wert pro Kopf und Monat	Verwaltung	Frau	91-95 Jahre	164.99	167.50	154.12	147.86	143.82	144.08	143.55	142.55	143.94	146.25	157.40
1133	Wert pro Kopf und Monat	Verwaltung	Frau	96 und mehr Jahre	216.70	232.14	214.66	198.60	199.22	195.54	193.25	192.36	190.94	193.70	207.38

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample